Click Here to View Step by Step sqlite Database synchronization with ms sql server MERGE (mssqlserver_Tablename) AS W USING openquery(SYNCUSERSINFO, 'select * from Sqlite_Tablename') AS T ON (W.ID= T.ID) WHEN NOT MATCHED BY TARGET THEN INSERT(Columns) VALUES (Columns);
sqlite Database synchronization with ms sql server MERGE (mssqlserver_Tablename) AS W
USING openquery(SYNCUSERSINFO, 'select * from Sqlite_Tablename') AS T
ON (W.ID= T.ID)
WHEN NOT MATCHED BY TARGET THEN
INSERT(Columns)
VALUES (Columns);
6 4
Next Post